Create KPI Cards
12
To create Year and KPI Cards (4,5,6,7 in the dashboard)
Step 1.
a. Create Year slicer. Click on the slicer, select date table then select year from date hierarchy.
b. To Format, Go to General X position = 401, y position = 0, width = 251, height = 109
c. Turn Slider header OFF, Turn Slider ON, Color - Black
d. Turn Title On, type Year for title, font Color Black, background color White,
Alignment Center, Text Size 14, Font Family Arial Black
e. Turn Background ON, color White
d. Turn Visual header ON
Step 2.
a. To create KPI card select KPI Card in the Visualizations then select the measure
Total Attacks from the table drag and drop it in the field area.
b. To Format, Go to General X position = 641, y position = 0, width = 197, height = 109
c. Data Label Color Black, Text Size 33, Font Family DIN
d. Set Category Off, Word Wrap ON, Turn Title On, type Total Attacks for the title, font
Color Black, background color White, Alignment Center, Text Size 14, Font Family
Arial Black
e. Turn Background ON ,color White
f. Turn Visual header ON
Follow the Gif below.
Step 3. Create Shark Attacks Per Yr KPI Card.
a. To create KPI card select KPI Card in the Visualizations then select the measure
Avg Attacks Per Yr measure from the table drag and drop it in the field area.
b. To Format, go to General X position = 837, y position = 0, width = 252, height = 109
c. Data Label Color Black, Text Size 33, Font Family DIN
d. Set Category Off, Word Wrap ON
e. Turn Title On, type Shark Attacks Per Yr for the title, font Color Black, background
color White, alignment Center, Text Size 14, Font Family Arial Black
d. Turn Background ON ,color White
e. Turn Visual header ON
Follow the Gif below.
Step 4 . Create %DOD KPI Card.
a. To create KPI card select KPI Card in the Visualizations then select the measure
%DOD measure from the table drag and drop it in the field area.
b. To Format, go to General X position = 1071, y position = 0, width = 209, height = 109
c. Data Label Color field value ColorForArrow, Text Size 33, Font Family DIN
d. Set Category Off, Word Wrap ON
e. Turn Title On, type %DOD for the title, font Color Black, background color White,
alignment Center, Text Size 14, Font Family Arial Black
d. Turn Background ON, color White
e. Turn Visual header ON
Follow the Gif below.
Step 5. Create Indicator
a. Select the KPI Card from the visualizations, Select ArrowForDOD% measure from the table, drag and drop in the field area.
b. To Format, go to General X position = 1214, y position = 0, width = 66, height = 51
c. Data Label Color Field value ColorForArrow, Text Size 30, Font Family DIN
d. Set Category Off, Word Wrap ON
e. Turn Background ON, Color white
f. Rearrange the indicator top right side if the format makes different than Gif.
Follow the Gif below.
KPI requirements in Power BI:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
Create KPI Cards
12
To create Year and KPI Cards (4,5,6,7 in the dashboard)
Step 1.
a. Create Year slicer. Click on the slicer, select date table then select year from date hierarchy.
b. To Format, Go to General X position = 401, y position = 0, width = 251, height = 109
c. Turn Slider header OFF, Turn Slider ON, Color - Black
d. Turn Title On, type Year for title, font Color Black, background color White,
Alignment Center, Text Size 14, Font Family Arial Black
e. Turn Background ON, color White
d. Turn Visual header ON
Step 2.
a. To create KPI card select KPI Card in the Visualizations then select the measure
Total Attacks from the table drag and drop it in the field area.
b. To Format, Go to General X position = 641, y position = 0, width = 197, height = 109
c. Data Label Color Black, Text Size 33, Font Family DIN
d. Set Category Off, Word Wrap ON, Turn Title On, type Total Attacks for the title, font
Color Black, background color White, Alignment Center, Text Size 14, Font Family
Arial Black
e. Turn Background ON ,color White
f. Turn Visual header ON
Follow the Gif below.
Step 3. Create Shark Attacks Per Yr KPI Card.
a. To create KPI card select KPI Card in the Visualizations then select the measure
Avg Attacks Per Yr measure from the table drag and drop it in the field area.
b. To Format, go to General X position = 837, y position = 0, width = 252, height = 109
c. Data Label Color Black, Text Size 33, Font Family DIN
d. Set Category Off, Word Wrap ON
e. Turn Title On, type Shark Attacks Per Yr for the title, font Color Black, background
color White, alignment Center, Text Size 14, Font Family Arial Black
d. Turn Background ON ,color White
e. Turn Visual header ON
Follow the Gif below.
Step 4 . Create %DOD KPI Card.
a. To create KPI card select KPI Card in the Visualizations then select the measure
%DOD measure from the table drag and drop it in the field area.
b. To Format, go to General X position = 1071, y position = 0, width = 209, height = 109
c. Data Label Color field value ColorForArrow, Text Size 33, Font Family DIN
d. Set Category Off, Word Wrap ON
e. Turn Title On, type %DOD for the title, font Color Black, background color White,
alignment Center, Text Size 14, Font Family Arial Black
d. Turn Background ON, color White
e. Turn Visual header ON
Follow the Gif below.
Step 5. Create Indicator
a. Select the KPI Card from the visualizations, Select ArrowForDOD% measure from the table, drag and drop in the field area.
b. To Format, go to General X position = 1214, y position = 0, width = 66, height = 51
c. Data Label Color Field value ColorForArrow, Text Size 30, Font Family DIN
d. Set Category Off, Word Wrap ON
e. Turn Background ON, Color white
f. Rearrange the indicator top right side if the format makes different than Gif.
Follow the Gif below.
KPI requirements in Power BI:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
